using System;
using System.Collections.Generic;
using System.Text;
using Shc.Sql;
using Shc.Json;
namespace Slqj.Data
{
	public static class TableViewGuestRoom
	{
		public const string Table = "View_GuestRoom";
		public const string GuestRoomID = "GuestRoomID";
		public const string HotelInfoID = "HotelInfoID";
		public const string ApproveStatusID = "ApproveStatusID";
		public const string GuestRoomName = "GuestRoomName";
		public const string OriginalPrice = "OriginalPrice";
		public const string WeekdaysPrice = "WeekdaysPrice";
		public const string WeekendPrice = "WeekendPrice";
		public const string HolidayPrice = "HolidayPrice";
		public const string Profit = "Profit";
		public const string SettlementPrice = "SettlementPrice";
		public const string Discount = "Discount";
		public const string BackPoint = "BackPoint";
		public const string GuestRoomStatus = "GuestRoomStatus";
		public const string Quantity = "Quantity";
		public const string Sort = "Sort";
		public const string Creater = "Creater";
		public const string CreatedBy = "CreatedBy";
		public const string Created = "Created";
		public const string Modified = "Modified";
		public const string ModifiedBy = "ModifiedBy";
		public const string ModifiedByID = "ModifiedByID";
		public const string MemberAmount = "MemberAmount";
		public const string SystemAmount = "SystemAmount";
		public const string GuestRoomUrl = "GuestRoomUrl";
		public const string SystemProfit = "SystemProfit";
		public const string WeekdaysPriceSettled = "WeekdaysPriceSettled";
		public const string WeekendPriceSettled = "WeekendPriceSettled";
		public const string HolidayPriceSettled = "HolidayPriceSettled";
		public const string BroadbandCase = "BroadbandCase";
		public const string RoomSize = "RoomSize";
		public const string Breakfast = "Breakfast";
		public const string GuestRoomDes = "GuestRoomDes";
		public const string SystemWeekendProfit = "SystemWeekendProfit";
		public const string SystemHolidayProfit = "SystemHolidayProfit";
		public const string Storey = "Storey";
		public const string BedType = "BedType";
		public const string BedWide = "BedWide";
		public const string Facility = "Facility";
		public const string HotelName = "HotelName";
		public const string ApproveStatusName = "ApproveStatusName";
	}
	
	[Serializable]
	public class BaseViewGuestRoom
		: IDbSessionEntity, IJsonClass
	{
		int m_GuestRoomID;
		/// <summary>
        /// 
        /// </summary>
        public int GuestRoomID
        {
            get { return m_GuestRoomID; }
            set { m_GuestRoomID = value; }
        }
		
		int? m_HotelInfoID;
		/// <summary>
        /// 
        /// </summary>
        public int? HotelInfoID
        {
            get { return m_HotelInfoID; }
            set { m_HotelInfoID = value; }
        }
		
		int? m_ApproveStatusID;
		/// <summary>
        /// 
        /// </summary>
        public int? ApproveStatusID
        {
            get { return m_ApproveStatusID; }
            set { m_ApproveStatusID = value; }
        }
		
		string m_GuestRoomName;
		/// <summary>
        /// 
        /// </summary>
        public string GuestRoomName
        {
            get { return m_GuestRoomName; }
            set { m_GuestRoomName = value; }
        }
		
		double m_OriginalPrice;
		/// <summary>
        /// 
        /// </summary>
        public double OriginalPrice
        {
            get { return m_OriginalPrice; }
            set { m_OriginalPrice = value; }
        }
		
		double m_WeekdaysPrice;
		/// <summary>
        /// 
        /// </summary>
        public double WeekdaysPrice
        {
            get { return m_WeekdaysPrice; }
            set { m_WeekdaysPrice = value; }
        }
		
		double m_WeekendPrice;
		/// <summary>
        /// 
        /// </summary>
        public double WeekendPrice
        {
            get { return m_WeekendPrice; }
            set { m_WeekendPrice = value; }
        }
		
		double m_HolidayPrice;
		/// <summary>
        /// 
        /// </summary>
        public double HolidayPrice
        {
            get { return m_HolidayPrice; }
            set { m_HolidayPrice = value; }
        }
		
		double m_Profit;
		/// <summary>
        /// 
        /// </summary>
        public double Profit
        {
            get { return m_Profit; }
            set { m_Profit = value; }
        }
		
		double m_SettlementPrice;
		/// <summary>
        /// 
        /// </summary>
        public double SettlementPrice
        {
            get { return m_SettlementPrice; }
            set { m_SettlementPrice = value; }
        }
		
		double m_Discount;
		/// <summary>
        /// 
        /// </summary>
        public double Discount
        {
            get { return m_Discount; }
            set { m_Discount = value; }
        }
		
		double m_BackPoint;
		/// <summary>
        /// 
        /// </summary>
        public double BackPoint
        {
            get { return m_BackPoint; }
            set { m_BackPoint = value; }
        }
		
		int m_GuestRoomStatus;
		/// <summary>
        /// 
        /// </summary>
        public int GuestRoomStatus
        {
            get { return m_GuestRoomStatus; }
            set { m_GuestRoomStatus = value; }
        }
		
		int m_Quantity;
		/// <summary>
        /// 
        /// </summary>
        public int Quantity
        {
            get { return m_Quantity; }
            set { m_Quantity = value; }
        }
		
		int m_Sort;
		/// <summary>
        /// 
        /// </summary>
        public int Sort
        {
            get { return m_Sort; }
            set { m_Sort = value; }
        }
		
		int m_Creater;
		/// <summary>
        /// 
        /// </summary>
        public int Creater
        {
            get { return m_Creater; }
            set { m_Creater = value; }
        }
		
		string m_CreatedBy;
		/// <summary>
        /// 
        /// </summary>
        public string CreatedBy
        {
            get { return m_CreatedBy; }
            set { m_CreatedBy = value; }
        }
		
		DateTime m_Created;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Created
        {
            get { return m_Created; }
            set { m_Created = value; }
        }
		
		DateTime m_Modified;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Modified
        {
            get { return m_Modified; }
            set { m_Modified = value; }
        }
		
		string m_ModifiedBy;
		/// <summary>
        /// 
        /// </summary>
        public string ModifiedBy
        {
            get { return m_ModifiedBy; }
            set { m_ModifiedBy = value; }
        }
		
		int? m_ModifiedByID;
		/// <summary>
        /// 
        /// </summary>
        public int? ModifiedByID
        {
            get { return m_ModifiedByID; }
            set { m_ModifiedByID = value; }
        }
		
		double m_MemberAmount;
		/// <summary>
        /// 
        /// </summary>
        public double MemberAmount
        {
            get { return m_MemberAmount; }
            set { m_MemberAmount = value; }
        }
		
		double m_SystemAmount;
		/// <summary>
        /// 
        /// </summary>
        public double SystemAmount
        {
            get { return m_SystemAmount; }
            set { m_SystemAmount = value; }
        }
		
		string m_GuestRoomUrl;
		/// <summary>
        /// 
        /// </summary>
        public string GuestRoomUrl
        {
            get { return m_GuestRoomUrl; }
            set { m_GuestRoomUrl = value; }
        }
		
		double m_SystemProfit;
		/// <summary>
        /// 
        /// </summary>
        public double SystemProfit
        {
            get { return m_SystemProfit; }
            set { m_SystemProfit = value; }
        }
		
		double m_WeekdaysPriceSettled;
		/// <summary>
        /// 
        /// </summary>
        public double WeekdaysPriceSettled
        {
            get { return m_WeekdaysPriceSettled; }
            set { m_WeekdaysPriceSettled = value; }
        }
		
		double m_WeekendPriceSettled;
		/// <summary>
        /// 
        /// </summary>
        public double WeekendPriceSettled
        {
            get { return m_WeekendPriceSettled; }
            set { m_WeekendPriceSettled = value; }
        }
		
		double m_HolidayPriceSettled;
		/// <summary>
        /// 
        /// </summary>
        public double HolidayPriceSettled
        {
            get { return m_HolidayPriceSettled; }
            set { m_HolidayPriceSettled = value; }
        }
		
		string m_BroadbandCase;
		/// <summary>
        /// 
        /// </summary>
        public string BroadbandCase
        {
            get { return m_BroadbandCase; }
            set { m_BroadbandCase = value; }
        }
		
		double m_RoomSize;
		/// <summary>
        /// 
        /// </summary>
        public double RoomSize
        {
            get { return m_RoomSize; }
            set { m_RoomSize = value; }
        }
		
		string m_Breakfast;
		/// <summary>
        /// 
        /// </summary>
        public string Breakfast
        {
            get { return m_Breakfast; }
            set { m_Breakfast = value; }
        }
		
		string m_GuestRoomDes;
		/// <summary>
        /// 
        /// </summary>
        public string GuestRoomDes
        {
            get { return m_GuestRoomDes; }
            set { m_GuestRoomDes = value; }
        }
		
		double m_SystemWeekendProfit;
		/// <summary>
        /// 
        /// </summary>
        public double SystemWeekendProfit
        {
            get { return m_SystemWeekendProfit; }
            set { m_SystemWeekendProfit = value; }
        }
		
		double m_SystemHolidayProfit;
		/// <summary>
        /// 
        /// </summary>
        public double SystemHolidayProfit
        {
            get { return m_SystemHolidayProfit; }
            set { m_SystemHolidayProfit = value; }
        }
		
		string m_Storey;
		/// <summary>
        /// 
        /// </summary>
        public string Storey
        {
            get { return m_Storey; }
            set { m_Storey = value; }
        }
		
		string m_BedType;
		/// <summary>
        /// 
        /// </summary>
        public string BedType
        {
            get { return m_BedType; }
            set { m_BedType = value; }
        }
		
		string m_BedWide;
		/// <summary>
        /// 
        /// </summary>
        public string BedWide
        {
            get { return m_BedWide; }
            set { m_BedWide = value; }
        }
		
		string m_Facility;
		/// <summary>
        /// 
        /// </summary>
        public string Facility
        {
            get { return m_Facility; }
            set { m_Facility = value; }
        }
		
		string m_HotelName;
		/// <summary>
        /// 
        /// </summary>
        public string HotelName
        {
            get { return m_HotelName; }
            set { m_HotelName = value; }
        }
		
		string m_ApproveStatusName;
		/// <summary>
        /// 
        /// </summary>
        public string ApproveStatusName
        {
            get { return m_ApproveStatusName; }
            set { m_ApproveStatusName = value; }
        }
		
		
		#region IDbSessionEntity Members
		public void ReadDBData(RowDataReader reader)
        {
            m_GuestRoomID = reader[TableViewGuestRoom.GuestRoomID];
            m_HotelInfoID = reader[TableViewGuestRoom.HotelInfoID];
            m_ApproveStatusID = reader[TableViewGuestRoom.ApproveStatusID];
            m_GuestRoomName = reader[TableViewGuestRoom.GuestRoomName];
            m_OriginalPrice = reader[TableViewGuestRoom.OriginalPrice];
            m_WeekdaysPrice = reader[TableViewGuestRoom.WeekdaysPrice];
            m_WeekendPrice = reader[TableViewGuestRoom.WeekendPrice];
            m_HolidayPrice = reader[TableViewGuestRoom.HolidayPrice];
            m_Profit = reader[TableViewGuestRoom.Profit];
            m_SettlementPrice = reader[TableViewGuestRoom.SettlementPrice];
            m_Discount = reader[TableViewGuestRoom.Discount];
            m_BackPoint = reader[TableViewGuestRoom.BackPoint];
            m_GuestRoomStatus = reader[TableViewGuestRoom.GuestRoomStatus];
            m_Quantity = reader[TableViewGuestRoom.Quantity];
            m_Sort = reader[TableViewGuestRoom.Sort];
            m_Creater = reader[TableViewGuestRoom.Creater];
            m_CreatedBy = reader[TableViewGuestRoom.CreatedBy];
            m_Created = reader[TableViewGuestRoom.Created];
            m_Modified = reader[TableViewGuestRoom.Modified];
            m_ModifiedBy = reader[TableViewGuestRoom.ModifiedBy];
            m_ModifiedByID = reader[TableViewGuestRoom.ModifiedByID];
            m_MemberAmount = reader[TableViewGuestRoom.MemberAmount];
            m_SystemAmount = reader[TableViewGuestRoom.SystemAmount];
            m_GuestRoomUrl = reader[TableViewGuestRoom.GuestRoomUrl];
            m_SystemProfit = reader[TableViewGuestRoom.SystemProfit];
            m_WeekdaysPriceSettled = reader[TableViewGuestRoom.WeekdaysPriceSettled];
            m_WeekendPriceSettled = reader[TableViewGuestRoom.WeekendPriceSettled];
            m_HolidayPriceSettled = reader[TableViewGuestRoom.HolidayPriceSettled];
            m_BroadbandCase = reader[TableViewGuestRoom.BroadbandCase];
            m_RoomSize = reader[TableViewGuestRoom.RoomSize];
            m_Breakfast = reader[TableViewGuestRoom.Breakfast];
            m_GuestRoomDes = reader[TableViewGuestRoom.GuestRoomDes];
            m_SystemWeekendProfit = reader[TableViewGuestRoom.SystemWeekendProfit];
            m_SystemHolidayProfit = reader[TableViewGuestRoom.SystemHolidayProfit];
            m_Storey = reader[TableViewGuestRoom.Storey];
            m_BedType = reader[TableViewGuestRoom.BedType];
            m_BedWide = reader[TableViewGuestRoom.BedWide];
            m_Facility = reader[TableViewGuestRoom.Facility];
            m_HotelName = reader[TableViewGuestRoom.HotelName];
            m_ApproveStatusName = reader[TableViewGuestRoom.ApproveStatusName];
        }
		
		public void WriteDBData(RowDataWriter writer)
        {
        }

        public void SetIdentityAfterInsert(DBObject idd)
        {
        }
		
		public string TableName
        {
            get { return TableViewGuestRoom.Table; }
        }
		#endregion
		
		
		#region IJsonClass Members

        public void JsonDeSerializeObj(JsonHashTable hashToRead)
        {
             m_GuestRoomID = hashToRead["GuestRoomID"];
			 
             m_HotelInfoID = hashToRead["HotelInfoID"];
			 
             m_ApproveStatusID = hashToRead["ApproveStatusID"];
			 
             m_GuestRoomName = hashToRead["GuestRoomName"];
			 
             m_OriginalPrice = hashToRead["OriginalPrice"];
			 
             m_WeekdaysPrice = hashToRead["WeekdaysPrice"];
			 
             m_WeekendPrice = hashToRead["WeekendPrice"];
			 
             m_HolidayPrice = hashToRead["HolidayPrice"];
			 
             m_Profit = hashToRead["Profit"];
			 
             m_SettlementPrice = hashToRead["SettlementPrice"];
			 
             m_Discount = hashToRead["Discount"];
			 
             m_BackPoint = hashToRead["BackPoint"];
			 
             m_GuestRoomStatus = hashToRead["GuestRoomStatus"];
			 
             m_Quantity = hashToRead["Quantity"];
			 
             m_Sort = hashToRead["Sort"];
			 
             m_Creater = hashToRead["Creater"];
			 
             m_CreatedBy = hashToRead["CreatedBy"];
			 
             m_Created = hashToRead["Created"];
			 
             m_Modified = hashToRead["Modified"];
			 
             m_ModifiedBy = hashToRead["ModifiedBy"];
			 
             m_ModifiedByID = hashToRead["ModifiedByID"];
			 
             m_MemberAmount = hashToRead["MemberAmount"];
			 
             m_SystemAmount = hashToRead["SystemAmount"];
			 
             m_GuestRoomUrl = hashToRead["GuestRoomUrl"];
			 
             m_SystemProfit = hashToRead["SystemProfit"];
			 
             m_WeekdaysPriceSettled = hashToRead["WeekdaysPriceSettled"];
			 
             m_WeekendPriceSettled = hashToRead["WeekendPriceSettled"];
			 
             m_HolidayPriceSettled = hashToRead["HolidayPriceSettled"];
			 
             m_BroadbandCase = hashToRead["BroadbandCase"];
			 
             m_RoomSize = hashToRead["RoomSize"];
			 
             m_Breakfast = hashToRead["Breakfast"];
			 
             m_GuestRoomDes = hashToRead["GuestRoomDes"];
			 
             m_SystemWeekendProfit = hashToRead["SystemWeekendProfit"];
			 
             m_SystemHolidayProfit = hashToRead["SystemHolidayProfit"];
			 
             m_Storey = hashToRead["Storey"];
			 
             m_BedType = hashToRead["BedType"];
			 
             m_BedWide = hashToRead["BedWide"];
			 
             m_Facility = hashToRead["Facility"];
			 
             m_HotelName = hashToRead["HotelName"];
			 
             m_ApproveStatusName = hashToRead["ApproveStatusName"];
			 
        }

        public void JsonSerializeObj(JsonHashTable hashToFill)
        {
            hashToFill["GuestRoomID"] = GuestRoomID;
			
            hashToFill["HotelInfoID"] = HotelInfoID;
			
            hashToFill["ApproveStatusID"] = ApproveStatusID;
			
            hashToFill["GuestRoomName"] = GuestRoomName;
			
            hashToFill["OriginalPrice"] = OriginalPrice;
			
            hashToFill["WeekdaysPrice"] = WeekdaysPrice;
			
            hashToFill["WeekendPrice"] = WeekendPrice;
			
            hashToFill["HolidayPrice"] = HolidayPrice;
			
            hashToFill["Profit"] = Profit;
			
            hashToFill["SettlementPrice"] = SettlementPrice;
			
            hashToFill["Discount"] = Discount;
			
            hashToFill["BackPoint"] = BackPoint;
			
            hashToFill["GuestRoomStatus"] = GuestRoomStatus;
			
            hashToFill["Quantity"] = Quantity;
			
            hashToFill["Sort"] = Sort;
			
            hashToFill["Creater"] = Creater;
			
            hashToFill["CreatedBy"] = CreatedBy;
			
            hashToFill["Created"] = Created;
			
            hashToFill["Modified"] = Modified;
			
            hashToFill["ModifiedBy"] = ModifiedBy;
			
            hashToFill["ModifiedByID"] = ModifiedByID;
			
            hashToFill["MemberAmount"] = MemberAmount;
			
            hashToFill["SystemAmount"] = SystemAmount;
			
            hashToFill["GuestRoomUrl"] = GuestRoomUrl;
			
            hashToFill["SystemProfit"] = SystemProfit;
			
            hashToFill["WeekdaysPriceSettled"] = WeekdaysPriceSettled;
			
            hashToFill["WeekendPriceSettled"] = WeekendPriceSettled;
			
            hashToFill["HolidayPriceSettled"] = HolidayPriceSettled;
			
            hashToFill["BroadbandCase"] = BroadbandCase;
			
            hashToFill["RoomSize"] = RoomSize;
			
            hashToFill["Breakfast"] = Breakfast;
			
            hashToFill["GuestRoomDes"] = GuestRoomDes;
			
            hashToFill["SystemWeekendProfit"] = SystemWeekendProfit;
			
            hashToFill["SystemHolidayProfit"] = SystemHolidayProfit;
			
            hashToFill["Storey"] = Storey;
			
            hashToFill["BedType"] = BedType;
			
            hashToFill["BedWide"] = BedWide;
			
            hashToFill["Facility"] = Facility;
			
            hashToFill["HotelName"] = HotelName;
			
            hashToFill["ApproveStatusName"] = ApproveStatusName;
			
        }

        #endregion
		
	}
}
